# describe 'news'
GET news

# muestro la cantidad de registros
# 2.365.984 registros (casi 2.5 millones de registros)
GET news/_count


GET news/_search
{
  "query": {
    "fuzzy": {
      "title": "kichilof"
    }
  }
}

# LIMIT 3
GET news/_search?size=3
{
  "query": {
    "fuzzy": {
      "title": "kichilof"
    }
  }
}

# ahora es ordenable, por el campo 'date'
PUT news/_mapping
{
  "properties": {
    "date": {
      "type": "text",
      "fielddata": true
    }
  }
}

GET /news/_search?size=3
{
  "query": {
    "fuzzy": {
      "title": "cristina"
    }
  },
  "sort": {
    "date": {
      "order": "desc"
    }
  }
}

GET /news/_search?size=3
{
  "query": {
    "term": {
      "title": "duran"
    }
  },
  "sort": {
    "date": {
      "order": "desc"
    }
  }
}

GET news/_search?size=1

GET news/_doc/1

# documentos con fechas invalidas
DELETE /news/_doc/0
DELETE /news/_doc/2365983

PUT news
{
  "mappings": {
    "properties": {
      "date": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss Z"
      }
    }
  }
}
# error --> resource_already_exists_exception"
# tendria que reindexar con este nuevo mapping


GET news/_search
{
  "query": {
    "range": {
      "date": {
        "gte": "2018-07-16",
        "lte": "2018-07-17"
      }
    }
  }
}

GET twitter
# post_date" : "2009-11-15T13:12:00",


DELETE test

GET test/_search

PUT /test/_doc/1
{
  "text": "este es el 1er documento",
  "count": 12,
  "price": 12.12,
  "date": "2019-05-27T17:10:12"
}




